193afa6fbe0c57358f9f0aae61bb5a0952714d9c,tests/frontend/org/voltdb/planner/TestPlansGroupBy.java,TestPlansGroupBy,testMultiPartitionMVBasedQuery_NoAggQuery,#,236

Before Change


        pns = compileToFragments("SELECT * FROM V_P1");
        checkMVReaggreateFeatureNoBottomAgg(pns, 2, 3); // 5 (# of select) - 2 (# of group-by)

        pns = compileToFragments("SELECT * FROM V_P1 order by V_A1");
        checkMVReaggreateFeatureNoBottomAgg(pns, 2, 3);

        pns = compileToFragments("SELECT * FROM V_P1 order by V_A1, V_B1");
        checkMVReaggreateFeatureNoBottomAgg(pns, 2, 3);

        pns = compileToFragments("SELECT * FROM V_P1 order by V_SUM_D1");
        checkMVReaggreateFeatureNoBottomAgg(pns, 2, 3);

        pns = compileToFragments("SELECT * FROM V_P1 limit 1");
        checkMVReaggreateFeatureNoBottomAgg(pns, 2, 3);

        pns = compileToFragments("SELECT * FROM V_P1 order by V_A1, V_B1 limit 1");
        checkMVReaggreateFeatureNoBottomAgg(pns, 2, 3);

        pns = compileToFragments("SELECT v_sum_c1 FROM V_P1");
        checkMVReaggreateFeatureNoBottomAgg(pns, 2, 1);

        pns = compileToFragments("SELECT v_sum_c1 FROM V_P1 order by v_sum_c1");
        checkMVReaggreateFeatureNoBottomAgg(pns, 2, 1);

After Change


//        FROM P1  GROUP BY A1, B1;

        String[] tbs = {"V_P1", "V_P1_ABS"};
        for (String tb: tbs) {
            pns = compileToFragments("SELECT * FROM " + tb);
            checkMVReaggreateFeatureNoBottomAgg(pns, 2, 3); // 5 (# of select) - 2 (# of group-by)

            pns = compileToFragments("SELECT * FROM " + tb + " order by V_A1");
            checkMVReaggreateFeatureNoBottomAgg(pns, 2, 3);

            pns = compileToFragments("SELECT * FROM " + tb + " order by V_A1, V_B1");
            checkMVReaggreateFeatureNoBottomAgg(pns, 2, 3);

            pns = compileToFragments("SELECT * FROM " + tb + " order by V_SUM_D1");
            checkMVReaggreateFeatureNoBottomAgg(pns, 2, 3);

            pns = compileToFragments("SELECT * FROM " + tb + " limit 1");
            checkMVReaggreateFeatureNoBottomAgg(pns, 2, 3);

            pns = compileToFragments("SELECT * FROM " + tb + " order by V_A1, V_B1 limit 1");
            checkMVReaggreateFeatureNoBottomAgg(pns, 2, 3);

            pns = compileToFragments("SELECT v_sum_c1 FROM " + tb + "");
            checkMVReaggreateFeatureNoBottomAgg(pns, 2, 1);

            pns = compileToFragments("SELECT v_sum_c1 FROM " + tb + " order by v_sum_c1");
            checkMVReaggreateFeatureNoBottomAgg(pns, 2, 1);